Dynamic query scheduling in parallel data warehouses
نویسندگان
چکیده
منابع مشابه
Dynamic Query Scheduling in Parallel Data Warehouses
Parallel processing is a key to high performance in very large data warehouse applications that execute complex analytical queries on huge amounts of data. Although parallel database systems (PDBSs) have been studied extensively in the past decades, the specifics of load balancing in parallel data warehouses have not been addressed in detail. In this study, we investigate how the load balancing...
متن کاملDynamic Query Scheduling in Data Integration Systems
Execution plans produced by traditional query optimizers for data integration queries may yield poor performance for several reasons. The cost estimates may be inaccurate, the memory available at run-time may be insufficient, or data delivery rate can be unpredictable. In this paper, we address the problem of unpredictable data arrival rate. We propose to dynamically schedule queries in order t...
متن کاملQuery Performance Optimization in XML Data Warehouses
Decision-support applications aim at facilitating the decision-making process. They collect data from operational databases and various sources, transform them into information available to decision-makers in a consolidated and consistent manner (Kimball & Ross, 2002). Furthermore, the development of the Web 2.0 and the proliferation of multimedia documents contributed to the analysis of data a...
متن کاملQuery Processing Issues in Data Warehouses
Data warehouses store organizational data extracted from many operational databases. They are mainly used for decision support and OLAP applications. As a result, queries to a data warehouse have unique idiosyncrasies that have to be separately addressed. Data warehouse queries usually are much less frequent than OLTP queries and touch upon much more data than a typical OLTP query. In addition,...
متن کاملImproving Query Performance in Virtual Data Warehouses
In order to improve the quality of Business Intelligence Systems in an organization we can choose to build the system using BI techniques such as OLAP and data warehousing or by using traditional reports based on SQL queries. The cost and developing time for BI tools is greater than those for SQL Reports and these factors are important in taking decisions on what type of techniques we used for ...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Concurrency and Computation: Practice and Experience
سال: 2003
ISSN: 1532-0626
DOI: 10.1002/cpe.786